SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE [dbo].[usp_DeleteEmployerUploadFile]
    (
      @JOL_Employer_Account VARCHAR(50)
    )
AS 
    UPDATE  dbo.JOL_Employer
    SET     JOL_Employer_CredentialsFileLink = ''
    WHERE   JOL_Employer_Account = @JOL_Employer_Account
GO
